{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/ankitgupta/anaconda/lib/python2.7/site-packages/sklearn/cross_validation.py:44: DeprecationWarning: This module was deprecated in version 0.18 in favor of the model_selection module into which all the refactored classes and functions are moved. Also note that the interface of the new CV iterators are different from that of this module. This module will be removed in 0.20.\n",
      "  \"This module will be removed in 0.20.\", DeprecationWarning)\n",
      "/Users/ankitgupta/anaconda/lib/python2.7/site-packages/sklearn/grid_search.py:43: DeprecationWarning: This module was deprecated in version 0.18 in favor of the model_selection module into which all the refactored classes and functions are moved. This module will be removed in 0.20.\n",
      "  DeprecationWarning)\n"
     ]
    }
   ],
   "source": [
    "\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "from sklearn.linear_model import LogisticRegression\n",
    "from sklearn.feature_extraction.text import TfidfVectorizer\n",
    "from sklearn.svm import SVC\n",
    "from sklearn.decomposition import TruncatedSVD\n",
    "from sklearn.preprocessing import StandardScaler\n",
    "from sklearn import decomposition, pipeline, metrics, grid_search\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "air_visit_data = pd.read_csv('air_visit_data.csv')\n",
    "sample_submission = pd.read_csv('sample_submission.csv')\n",
    "sample_submission['air_store_id'] = sample_submission['id'].apply(lambda x: x.split('_')[0]+str('_') +x.split('_')[1])\n",
    "sample_submission['visit_date'] = sample_submission['id'].apply(lambda x: x.split('_')[2])\n",
    "sample_submission['visit_date'] = pd.to_datetime(sample_submission['visit_date'],format= '%Y-%m-%d %H:%M:%S')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Timestamp('2016-01-01 00:00:00')"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "air_visit_data['visit_date'] = pd.to_datetime(air_visit_data['visit_date'],format= '%Y-%m-%d')\n",
    "air_visit_data.visit_date.min()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "air_visit_data['visit_date_month'] =air_visit_data.visit_date.dt.month\n",
    "air_visit_data['visit_date_dayofw'] =air_visit_data.visit_date.dt.dayofweek\n",
    "air_visit_data['visit_date_year'] =air_visit_data.visit_date.dt.year\n",
    "air_visit_data['visit_date_dayofm'] =air_visit_data.visit_date.dt.day\n",
    "air_visit_data['weekofyear'] =air_visit_data.visit_date.dt.weekofyear"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df=air_visit_data.groupby(['air_store_id','visit_date_month']).agg('mean')['visitors'].reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index([u'air_store_id', u'visit_date_month', u'visitors'], dtype='object')"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df = df.pivot(index='air_store_id', columns='visit_date_month', values='visitors').reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df = df[['air_store_id', 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df.columns = ['air_store_id', 'm0', 'm1', 'm2', 'm3', 'm4', 'm5', 'm6','m7', 'm8', 'm9', 'm10', 'm11']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "air_store_id      0\n",
       "m0               12\n",
       "m1               10\n",
       "m2                1\n",
       "m3                4\n",
       "m4              515\n",
       "m5              515\n",
       "m6               30\n",
       "m7               27\n",
       "m8               22\n",
       "m9               20\n",
       "m10              18\n",
       "m11              18\n",
       "dtype: int64"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df = df.drop(['m4','m5'],axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df.replace(np.nan,0,inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "df.to_csv('air_store_month_wise_mean.csv',index= False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>air_store_id</th>\n",
       "      <th>m0</th>\n",
       "      <th>m1</th>\n",
       "      <th>m2</th>\n",
       "      <th>m3</th>\n",
       "      <th>m6</th>\n",
       "      <th>m7</th>\n",
       "      <th>m8</th>\n",
       "      <th>m9</th>\n",
       "      <th>m10</th>\n",
       "      <th>m11</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>air_00a91d42b08b08d9</td>\n",
       "      <td>25.869565</td>\n",
       "      <td>29.652174</td>\n",
       "      <td>29.384615</td>\n",
       "      <td>27.222222</td>\n",
       "      <td>26.080000</td>\n",
       "      <td>24.166667</td>\n",
       "      <td>22.833333</td>\n",
       "      <td>23.250000</td>\n",
       "      <td>22.625000</td>\n",
       "      <td>30.428571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>air_0164b9927d20bcc3</td>\n",
       "      <td>10.789474</td>\n",
       "      <td>7.476190</td>\n",
       "      <td>9.625000</td>\n",
       "      <td>8.315789</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>10.000000</td>\n",
       "      <td>8.260870</td>\n",
       "      <td>10.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>air_0241aa3964b7f861</td>\n",
       "      <td>9.540000</td>\n",
       "      <td>9.212766</td>\n",
       "      <td>9.962264</td>\n",
       "      <td>10.250000</td>\n",
       "      <td>8.178571</td>\n",
       "      <td>10.125000</td>\n",
       "      <td>10.954545</td>\n",
       "      <td>9.153846</td>\n",
       "      <td>9.600000</td>\n",
       "      <td>12.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>air_0328696196e46f18</td>\n",
       "      <td>7.714286</td>\n",
       "      <td>7.571429</td>\n",
       "      <td>9.470588</td>\n",
       "      <td>8.384615</td>\n",
       "      <td>8.000000</td>\n",
       "      <td>6.100000</td>\n",
       "      <td>10.500000</td>\n",
       "      <td>10.666667</td>\n",
       "      <td>3.888889</td>\n",
       "      <td>10.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>air_034a3d5b40d5b1b1</td>\n",
       "      <td>5.733333</td>\n",
       "      <td>27.428571</td>\n",
       "      <td>23.806452</td>\n",
       "      <td>22.409091</td>\n",
       "      <td>13.777778</td>\n",
       "      <td>11.444444</td>\n",
       "      <td>9.333333</td>\n",
       "      <td>7.407407</td>\n",
       "      <td>12.272727</td>\n",
       "      <td>9.357143</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>air_036d4f1ee7285390</td>\n",
       "      <td>17.807692</td>\n",
       "      <td>16.071429</td>\n",
       "      <td>20.161290</td>\n",
       "      <td>20.590909</td>\n",
       "      <td>29.483871</td>\n",
       "      <td>32.840000</td>\n",
       "      <td>24.733333</td>\n",
       "      <td>23.451613</td>\n",
       "      <td>21.266667</td>\n",
       "      <td>17.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>air_0382c794b73b51ad</td>\n",
       "      <td>13.864865</td>\n",
       "      <td>24.322581</td>\n",
       "      <td>28.333333</td>\n",
       "      <td>27.954545</td>\n",
       "      <td>22.857143</td>\n",
       "      <td>21.166667</td>\n",
       "      <td>20.241379</td>\n",
       "      <td>23.962963</td>\n",
       "      <td>27.880000</td>\n",
       "      <td>32.464286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>air_03963426c9312048</td>\n",
       "      <td>40.722222</td>\n",
       "      <td>36.716981</td>\n",
       "      <td>45.051724</td>\n",
       "      <td>45.040816</td>\n",
       "      <td>37.038462</td>\n",
       "      <td>31.333333</td>\n",
       "      <td>34.884615</td>\n",
       "      <td>31.307692</td>\n",
       "      <td>31.370370</td>\n",
       "      <td>49.269231</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>air_04341b588bde96cd</td>\n",
       "      <td>35.543860</td>\n",
       "      <td>33.228070</td>\n",
       "      <td>41.387097</td>\n",
       "      <td>37.519231</td>\n",
       "      <td>38.806452</td>\n",
       "      <td>29.548387</td>\n",
       "      <td>35.400000</td>\n",
       "      <td>35.322581</td>\n",
       "      <td>34.200000</td>\n",
       "      <td>35.833333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>air_049f6d5b402a31b2</td>\n",
       "      <td>10.250000</td>\n",
       "      <td>11.541667</td>\n",
       "      <td>12.214286</td>\n",
       "      <td>12.894737</td>\n",
       "      <td>11.346154</td>\n",
       "      <td>12.111111</td>\n",
       "      <td>12.000000</td>\n",
       "      <td>9.777778</td>\n",
       "      <td>10.107143</td>\n",
       "      <td>13.200000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>air_04cae7c1bc9b2a0b</td>\n",
       "      <td>24.928571</td>\n",
       "      <td>24.928571</td>\n",
       "      <td>21.903226</td>\n",
       "      <td>20.545455</td>\n",
       "      <td>16.129032</td>\n",
       "      <td>15.322581</td>\n",
       "      <td>16.172414</td>\n",
       "      <td>23.870968</td>\n",
       "      <td>26.233333</td>\n",
       "      <td>31.233333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>air_0585011fa179bcce</td>\n",
       "      <td>4.500000</td>\n",
       "      <td>3.925926</td>\n",
       "      <td>5.392857</td>\n",
       "      <td>5.333333</td>\n",
       "      <td>7.000000</td>\n",
       "      <td>5.214286</td>\n",
       "      <td>4.250000</td>\n",
       "      <td>3.607143</td>\n",
       "      <td>3.814815</td>\n",
       "      <td>4.642857</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>air_05c325d315cc17f5</td>\n",
       "      <td>18.910714</td>\n",
       "      <td>19.982456</td>\n",
       "      <td>24.032258</td>\n",
       "      <td>24.826923</td>\n",
       "      <td>21.870968</td>\n",
       "      <td>22.965517</td>\n",
       "      <td>24.233333</td>\n",
       "      <td>23.225806</td>\n",
       "      <td>22.633333</td>\n",
       "      <td>25.774194</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>air_0647f17b4dc041c8</td>\n",
       "      <td>37.064516</td>\n",
       "      <td>35.444444</td>\n",
       "      <td>39.225806</td>\n",
       "      <td>30.636364</td>\n",
       "      <td>36.857143</td>\n",
       "      <td>30.428571</td>\n",
       "      <td>32.166667</td>\n",
       "      <td>41.322581</td>\n",
       "      <td>40.714286</td>\n",
       "      <td>38.354839</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>air_064e203265ee5753</td>\n",
       "      <td>20.272727</td>\n",
       "      <td>24.809524</td>\n",
       "      <td>24.916667</td>\n",
       "      <td>19.937500</td>\n",
       "      <td>19.291667</td>\n",
       "      <td>15.363636</td>\n",
       "      <td>16.708333</td>\n",
       "      <td>21.583333</td>\n",
       "      <td>21.227273</td>\n",
       "      <td>32.347826</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>air_066f0221b8a4d533</td>\n",
       "      <td>13.482759</td>\n",
       "      <td>10.740741</td>\n",
       "      <td>18.392857</td>\n",
       "      <td>12.428571</td>\n",
       "      <td>13.903226</td>\n",
       "      <td>16.379310</td>\n",
       "      <td>15.785714</td>\n",
       "      <td>10.464286</td>\n",
       "      <td>15.357143</td>\n",
       "      <td>15.571429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>air_06f95ac5c33aca10</td>\n",
       "      <td>17.617021</td>\n",
       "      <td>23.673469</td>\n",
       "      <td>26.672727</td>\n",
       "      <td>25.511111</td>\n",
       "      <td>22.888889</td>\n",
       "      <td>16.708333</td>\n",
       "      <td>16.346154</td>\n",
       "      <td>17.120000</td>\n",
       "      <td>22.038462</td>\n",
       "      <td>25.040000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>air_0728814bd98f7367</td>\n",
       "      <td>8.941176</td>\n",
       "      <td>9.518519</td>\n",
       "      <td>11.200000</td>\n",
       "      <td>9.900000</td>\n",
       "      <td>12.548387</td>\n",
       "      <td>9.285714</td>\n",
       "      <td>8.137931</td>\n",
       "      <td>9.633333</td>\n",
       "      <td>8.760000</td>\n",
       "      <td>9.416667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>air_0768ab3910f7967f</td>\n",
       "      <td>18.775000</td>\n",
       "      <td>25.027027</td>\n",
       "      <td>19.767442</td>\n",
       "      <td>25.897436</td>\n",
       "      <td>21.761905</td>\n",
       "      <td>10.086957</td>\n",
       "      <td>7.958333</td>\n",
       "      <td>23.764706</td>\n",
       "      <td>20.411765</td>\n",
       "      <td>24.318182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>air_07b314d83059c4d2</td>\n",
       "      <td>39.733333</td>\n",
       "      <td>35.464286</td>\n",
       "      <td>43.354839</td>\n",
       "      <td>37.272727</td>\n",
       "      <td>26.387097</td>\n",
       "      <td>25.096774</td>\n",
       "      <td>22.600000</td>\n",
       "      <td>24.838710</td>\n",
       "      <td>31.933333</td>\n",
       "      <td>47.233333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>air_07bb665f9cdfbdfb</td>\n",
       "      <td>25.454545</td>\n",
       "      <td>27.510204</td>\n",
       "      <td>34.660000</td>\n",
       "      <td>30.700000</td>\n",
       "      <td>35.846154</td>\n",
       "      <td>42.500000</td>\n",
       "      <td>26.958333</td>\n",
       "      <td>26.423077</td>\n",
       "      <td>25.304348</td>\n",
       "      <td>23.080000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>air_082908692355165e</td>\n",
       "      <td>40.377358</td>\n",
       "      <td>42.075472</td>\n",
       "      <td>44.215686</td>\n",
       "      <td>47.897959</td>\n",
       "      <td>39.392857</td>\n",
       "      <td>29.821429</td>\n",
       "      <td>37.821429</td>\n",
       "      <td>39.851852</td>\n",
       "      <td>38.428571</td>\n",
       "      <td>48.571429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>air_083ddc520ea47e1e</td>\n",
       "      <td>8.304348</td>\n",
       "      <td>8.294118</td>\n",
       "      <td>19.380952</td>\n",
       "      <td>12.625000</td>\n",
       "      <td>12.291667</td>\n",
       "      <td>13.285714</td>\n",
       "      <td>8.954545</td>\n",
       "      <td>5.750000</td>\n",
       "      <td>4.941176</td>\n",
       "      <td>7.875000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>air_0845d8395f30c6bb</td>\n",
       "      <td>16.629630</td>\n",
       "      <td>22.407407</td>\n",
       "      <td>24.862069</td>\n",
       "      <td>22.954545</td>\n",
       "      <td>22.733333</td>\n",
       "      <td>19.551724</td>\n",
       "      <td>23.034483</td>\n",
       "      <td>20.965517</td>\n",
       "      <td>19.433333</td>\n",
       "      <td>27.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>air_084d98859256acf0</td>\n",
       "      <td>16.083333</td>\n",
       "      <td>14.818182</td>\n",
       "      <td>15.615385</td>\n",
       "      <td>15.526316</td>\n",
       "      <td>15.560000</td>\n",
       "      <td>14.840000</td>\n",
       "      <td>12.541667</td>\n",
       "      <td>14.080000</td>\n",
       "      <td>12.434783</td>\n",
       "      <td>15.370370</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>air_0867f7bebad6a649</td>\n",
       "      <td>22.269231</td>\n",
       "      <td>18.964286</td>\n",
       "      <td>29.344828</td>\n",
       "      <td>21.681818</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>25.840000</td>\n",
       "      <td>18.483871</td>\n",
       "      <td>19.433333</td>\n",
       "      <td>29.137931</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>air_08ba8cd01b3ba010</td>\n",
       "      <td>10.413793</td>\n",
       "      <td>10.433962</td>\n",
       "      <td>9.426230</td>\n",
       "      <td>10.280000</td>\n",
       "      <td>11.483871</td>\n",
       "      <td>9.733333</td>\n",
       "      <td>9.300000</td>\n",
       "      <td>10.724138</td>\n",
       "      <td>10.357143</td>\n",
       "      <td>12.433333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>air_08cb3c4ee6cd6a22</td>\n",
       "      <td>16.516129</td>\n",
       "      <td>14.142857</td>\n",
       "      <td>14.677419</td>\n",
       "      <td>12.842105</td>\n",
       "      <td>15.300000</td>\n",
       "      <td>15.100000</td>\n",
       "      <td>15.466667</td>\n",
       "      <td>15.600000</td>\n",
       "      <td>13.100000</td>\n",
       "      <td>17.766667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>air_08ef81d5b7a0d13f</td>\n",
       "      <td>10.125000</td>\n",
       "      <td>13.625000</td>\n",
       "      <td>13.640000</td>\n",
       "      <td>12.315789</td>\n",
       "      <td>14.071429</td>\n",
       "      <td>12.782609</td>\n",
       "      <td>16.909091</td>\n",
       "      <td>14.370370</td>\n",
       "      <td>12.695652</td>\n",
       "      <td>19.680000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>air_08f994758a1e76d4</td>\n",
       "      <td>28.357143</td>\n",
       "      <td>25.964286</td>\n",
       "      <td>27.733333</td>\n",
       "      <td>27.090909</td>\n",
       "      <td>23.225806</td>\n",
       "      <td>25.774194</td>\n",
       "      <td>22.931034</td>\n",
       "      <td>23.645161</td>\n",
       "      <td>29.241379</td>\n",
       "      <td>28.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>799</th>\n",
       "      <td>air_f6b2489ccf873c3b</td>\n",
       "      <td>15.534483</td>\n",
       "      <td>15.767857</td>\n",
       "      <td>15.612903</td>\n",
       "      <td>16.423077</td>\n",
       "      <td>16.129032</td>\n",
       "      <td>14.933333</td>\n",
       "      <td>16.300000</td>\n",
       "      <td>16.064516</td>\n",
       "      <td>15.733333</td>\n",
       "      <td>17.161290</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>800</th>\n",
       "      <td>air_f6bfd27e2e174d16</td>\n",
       "      <td>16.560000</td>\n",
       "      <td>16.961538</td>\n",
       "      <td>15.962963</td>\n",
       "      <td>11.550000</td>\n",
       "      <td>15.708333</td>\n",
       "      <td>15.772727</td>\n",
       "      <td>12.760000</td>\n",
       "      <td>11.884615</td>\n",
       "      <td>17.333333</td>\n",
       "      <td>20.137931</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>801</th>\n",
       "      <td>air_f6cdaf7b7fdc6d78</td>\n",
       "      <td>14.071429</td>\n",
       "      <td>11.750000</td>\n",
       "      <td>11.137931</td>\n",
       "      <td>9.272727</td>\n",
       "      <td>10.481481</td>\n",
       "      <td>11.259259</td>\n",
       "      <td>8.185185</td>\n",
       "      <td>10.428571</td>\n",
       "      <td>8.866667</td>\n",
       "      <td>9.692308</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>802</th>\n",
       "      <td>air_f8233ad00755c35c</td>\n",
       "      <td>29.961538</td>\n",
       "      <td>36.680000</td>\n",
       "      <td>33.827586</td>\n",
       "      <td>30.333333</td>\n",
       "      <td>37.961538</td>\n",
       "      <td>38.814815</td>\n",
       "      <td>35.392857</td>\n",
       "      <td>34.370370</td>\n",
       "      <td>34.222222</td>\n",
       "      <td>39.074074</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803</th>\n",
       "      <td>air_f85e21e543cf44f2</td>\n",
       "      <td>4.047619</td>\n",
       "      <td>4.523810</td>\n",
       "      <td>5.703704</td>\n",
       "      <td>5.411765</td>\n",
       "      <td>5.600000</td>\n",
       "      <td>5.428571</td>\n",
       "      <td>4.173913</td>\n",
       "      <td>6.125000</td>\n",
       "      <td>5.434783</td>\n",
       "      <td>3.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>804</th>\n",
       "      <td>air_f88898cd09f40496</td>\n",
       "      <td>10.225806</td>\n",
       "      <td>8.785714</td>\n",
       "      <td>7.774194</td>\n",
       "      <td>7.950000</td>\n",
       "      <td>8.642857</td>\n",
       "      <td>6.740741</td>\n",
       "      <td>7.933333</td>\n",
       "      <td>5.642857</td>\n",
       "      <td>6.961538</td>\n",
       "      <td>8.034483</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>805</th>\n",
       "      <td>air_f911308e19d64236</td>\n",
       "      <td>33.860000</td>\n",
       "      <td>31.166667</td>\n",
       "      <td>38.129630</td>\n",
       "      <td>37.021277</td>\n",
       "      <td>35.750000</td>\n",
       "      <td>33.391304</td>\n",
       "      <td>34.538462</td>\n",
       "      <td>37.346154</td>\n",
       "      <td>37.384615</td>\n",
       "      <td>46.185185</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>806</th>\n",
       "      <td>air_f9168b23fdfc1e52</td>\n",
       "      <td>9.440000</td>\n",
       "      <td>11.960000</td>\n",
       "      <td>11.600000</td>\n",
       "      <td>17.181818</td>\n",
       "      <td>12.285714</td>\n",
       "      <td>12.800000</td>\n",
       "      <td>12.740741</td>\n",
       "      <td>13.689655</td>\n",
       "      <td>11.384615</td>\n",
       "      <td>11.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>807</th>\n",
       "      <td>air_f927b2da69a82341</td>\n",
       "      <td>20.918919</td>\n",
       "      <td>19.804878</td>\n",
       "      <td>18.232558</td>\n",
       "      <td>15.967742</td>\n",
       "      <td>11.238095</td>\n",
       "      <td>11.550000</td>\n",
       "      <td>10.400000</td>\n",
       "      <td>10.000000</td>\n",
       "      <td>9.631579</td>\n",
       "      <td>13.181818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>808</th>\n",
       "      <td>air_f957c6d6467d4d90</td>\n",
       "      <td>9.966667</td>\n",
       "      <td>8.000000</td>\n",
       "      <td>10.433333</td>\n",
       "      <td>10.181818</td>\n",
       "      <td>9.935484</td>\n",
       "      <td>7.290323</td>\n",
       "      <td>11.666667</td>\n",
       "      <td>13.064516</td>\n",
       "      <td>10.900000</td>\n",
       "      <td>11.193548</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>809</th>\n",
       "      <td>air_f96765e800907c77</td>\n",
       "      <td>48.086957</td>\n",
       "      <td>46.250000</td>\n",
       "      <td>49.230769</td>\n",
       "      <td>45.800000</td>\n",
       "      <td>37.038462</td>\n",
       "      <td>23.040000</td>\n",
       "      <td>23.846154</td>\n",
       "      <td>25.192308</td>\n",
       "      <td>38.000000</td>\n",
       "      <td>46.592593</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>810</th>\n",
       "      <td>air_fa12b40b02fecfd8</td>\n",
       "      <td>14.500000</td>\n",
       "      <td>14.535714</td>\n",
       "      <td>16.193548</td>\n",
       "      <td>16.090909</td>\n",
       "      <td>19.666667</td>\n",
       "      <td>15.461538</td>\n",
       "      <td>15.384615</td>\n",
       "      <td>19.000000</td>\n",
       "      <td>12.960000</td>\n",
       "      <td>19.074074</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>811</th>\n",
       "      <td>air_fa4ffc9057812fa2</td>\n",
       "      <td>6.933333</td>\n",
       "      <td>5.386364</td>\n",
       "      <td>7.145833</td>\n",
       "      <td>6.081633</td>\n",
       "      <td>7.259259</td>\n",
       "      <td>4.750000</td>\n",
       "      <td>7.739130</td>\n",
       "      <td>9.000000</td>\n",
       "      <td>5.590909</td>\n",
       "      <td>7.130435</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>812</th>\n",
       "      <td>air_fab092c35776a9b1</td>\n",
       "      <td>10.553571</td>\n",
       "      <td>12.500000</td>\n",
       "      <td>13.966667</td>\n",
       "      <td>11.568627</td>\n",
       "      <td>7.258065</td>\n",
       "      <td>9.666667</td>\n",
       "      <td>9.928571</td>\n",
       "      <td>13.068966</td>\n",
       "      <td>11.000000</td>\n",
       "      <td>13.200000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>813</th>\n",
       "      <td>air_fb44f566d4f64a4e</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>21.333333</td>\n",
       "      <td>15.466667</td>\n",
       "      <td>25.161290</td>\n",
       "      <td>12.290323</td>\n",
       "      <td>13.655172</td>\n",
       "      <td>15.000000</td>\n",
       "      <td>12.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>814</th>\n",
       "      <td>air_fbadf737162a5ce3</td>\n",
       "      <td>16.938776</td>\n",
       "      <td>17.326531</td>\n",
       "      <td>17.490909</td>\n",
       "      <td>19.511111</td>\n",
       "      <td>24.538462</td>\n",
       "      <td>23.423077</td>\n",
       "      <td>23.076923</td>\n",
       "      <td>22.555556</td>\n",
       "      <td>18.720000</td>\n",
       "      <td>23.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>815</th>\n",
       "      <td>air_fc477473134e9ae5</td>\n",
       "      <td>20.423077</td>\n",
       "      <td>17.500000</td>\n",
       "      <td>19.129032</td>\n",
       "      <td>14.363636</td>\n",
       "      <td>19.709677</td>\n",
       "      <td>18.344828</td>\n",
       "      <td>16.068966</td>\n",
       "      <td>15.677419</td>\n",
       "      <td>16.392857</td>\n",
       "      <td>27.290323</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>816</th>\n",
       "      <td>air_fcd4492c83f1c6b9</td>\n",
       "      <td>27.632653</td>\n",
       "      <td>26.962264</td>\n",
       "      <td>27.344828</td>\n",
       "      <td>25.955556</td>\n",
       "      <td>29.172414</td>\n",
       "      <td>24.034483</td>\n",
       "      <td>28.000000</td>\n",
       "      <td>22.730769</td>\n",
       "      <td>24.428571</td>\n",
       "      <td>34.607143</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>817</th>\n",
       "      <td>air_fcfbdcf7b1f82c6e</td>\n",
       "      <td>38.409091</td>\n",
       "      <td>31.037037</td>\n",
       "      <td>42.080000</td>\n",
       "      <td>36.368421</td>\n",
       "      <td>33.366667</td>\n",
       "      <td>38.096774</td>\n",
       "      <td>38.551724</td>\n",
       "      <td>36.115385</td>\n",
       "      <td>28.423077</td>\n",
       "      <td>53.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>818</th>\n",
       "      <td>air_fd154088b1de6fa7</td>\n",
       "      <td>7.210526</td>\n",
       "      <td>5.176471</td>\n",
       "      <td>5.714286</td>\n",
       "      <td>6.705882</td>\n",
       "      <td>6.111111</td>\n",
       "      <td>4.437500</td>\n",
       "      <td>5.761905</td>\n",
       "      <td>7.466667</td>\n",
       "      <td>5.230769</td>\n",
       "      <td>6.300000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>819</th>\n",
       "      <td>air_fd6aac1043520e83</td>\n",
       "      <td>31.586957</td>\n",
       "      <td>34.340426</td>\n",
       "      <td>33.377358</td>\n",
       "      <td>33.380952</td>\n",
       "      <td>34.153846</td>\n",
       "      <td>26.173913</td>\n",
       "      <td>33.956522</td>\n",
       "      <td>31.840000</td>\n",
       "      <td>31.166667</td>\n",
       "      <td>39.086957</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>820</th>\n",
       "      <td>air_fdc02ec4a3d21ea4</td>\n",
       "      <td>17.933333</td>\n",
       "      <td>15.074074</td>\n",
       "      <td>11.866667</td>\n",
       "      <td>7.909091</td>\n",
       "      <td>13.321429</td>\n",
       "      <td>9.678571</td>\n",
       "      <td>10.964286</td>\n",
       "      <td>18.466667</td>\n",
       "      <td>18.766667</td>\n",
       "      <td>25.774194</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>821</th>\n",
       "      <td>air_fdcfef8bd859f650</td>\n",
       "      <td>3.458333</td>\n",
       "      <td>3.730769</td>\n",
       "      <td>4.566667</td>\n",
       "      <td>3.454545</td>\n",
       "      <td>2.117647</td>\n",
       "      <td>1.166667</td>\n",
       "      <td>1.333333</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>3.210526</td>\n",
       "      <td>4.592593</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>822</th>\n",
       "      <td>air_fe22ef5a9cbef123</td>\n",
       "      <td>25.660714</td>\n",
       "      <td>22.122807</td>\n",
       "      <td>32.919355</td>\n",
       "      <td>23.711538</td>\n",
       "      <td>21.580645</td>\n",
       "      <td>25.516129</td>\n",
       "      <td>26.900000</td>\n",
       "      <td>30.000000</td>\n",
       "      <td>26.400000</td>\n",
       "      <td>39.064516</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>823</th>\n",
       "      <td>air_fe58c074ec1445ea</td>\n",
       "      <td>26.857143</td>\n",
       "      <td>29.608696</td>\n",
       "      <td>28.166667</td>\n",
       "      <td>36.166667</td>\n",
       "      <td>30.772727</td>\n",
       "      <td>24.000000</td>\n",
       "      <td>25.909091</td>\n",
       "      <td>41.736842</td>\n",
       "      <td>26.500000</td>\n",
       "      <td>26.350000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>824</th>\n",
       "      <td>air_fea5dc9594450608</td>\n",
       "      <td>13.807692</td>\n",
       "      <td>18.041667</td>\n",
       "      <td>15.866667</td>\n",
       "      <td>16.227273</td>\n",
       "      <td>13.586207</td>\n",
       "      <td>13.750000</td>\n",
       "      <td>13.423077</td>\n",
       "      <td>12.433333</td>\n",
       "      <td>11.333333</td>\n",
       "      <td>17.344828</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>825</th>\n",
       "      <td>air_fee8dcf4d619598e</td>\n",
       "      <td>22.633333</td>\n",
       "      <td>27.714286</td>\n",
       "      <td>24.903226</td>\n",
       "      <td>26.727273</td>\n",
       "      <td>29.193548</td>\n",
       "      <td>26.233333</td>\n",
       "      <td>27.666667</td>\n",
       "      <td>23.838710</td>\n",
       "      <td>22.633333</td>\n",
       "      <td>29.640000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>826</th>\n",
       "      <td>air_fef9ccb3ba0da2f7</td>\n",
       "      <td>6.565217</td>\n",
       "      <td>6.041667</td>\n",
       "      <td>7.000000</td>\n",
       "      <td>9.421053</td>\n",
       "      <td>13.296296</td>\n",
       "      <td>10.772727</td>\n",
       "      <td>12.384615</td>\n",
       "      <td>10.333333</td>\n",
       "      <td>11.120000</td>\n",
       "      <td>8.720000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>827</th>\n",
       "      <td>air_ffcc2d5087e1b476</td>\n",
       "      <td>22.913043</td>\n",
       "      <td>19.791667</td>\n",
       "      <td>20.857143</td>\n",
       "      <td>19.500000</td>\n",
       "      <td>20.884615</td>\n",
       "      <td>18.090909</td>\n",
       "      <td>19.200000</td>\n",
       "      <td>18.560000</td>\n",
       "      <td>21.440000</td>\n",
       "      <td>20.880000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>828</th>\n",
       "      <td>air_fff68b929994bfbd</td>\n",
       "      <td>5.038462</td>\n",
       "      <td>4.821429</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>4.636364</td>\n",
       "      <td>5.076923</td>\n",
       "      <td>5.440000</td>\n",
       "      <td>4.857143</td>\n",
       "      <td>4.888889</td>\n",
       "      <td>5.827586</td>\n",
       "      <td>5.206897</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>829 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             air_store_id         m0         m1         m2         m3  \\\n",
       "0    air_00a91d42b08b08d9  25.869565  29.652174  29.384615  27.222222   \n",
       "1    air_0164b9927d20bcc3  10.789474   7.476190   9.625000   8.315789   \n",
       "2    air_0241aa3964b7f861   9.540000   9.212766   9.962264  10.250000   \n",
       "3    air_0328696196e46f18   7.714286   7.571429   9.470588   8.384615   \n",
       "4    air_034a3d5b40d5b1b1   5.733333  27.428571  23.806452  22.409091   \n",
       "5    air_036d4f1ee7285390  17.807692  16.071429  20.161290  20.590909   \n",
       "6    air_0382c794b73b51ad  13.864865  24.322581  28.333333  27.954545   \n",
       "7    air_03963426c9312048  40.722222  36.716981  45.051724  45.040816   \n",
       "8    air_04341b588bde96cd  35.543860  33.228070  41.387097  37.519231   \n",
       "9    air_049f6d5b402a31b2  10.250000  11.541667  12.214286  12.894737   \n",
       "10   air_04cae7c1bc9b2a0b  24.928571  24.928571  21.903226  20.545455   \n",
       "11   air_0585011fa179bcce   4.500000   3.925926   5.392857   5.333333   \n",
       "12   air_05c325d315cc17f5  18.910714  19.982456  24.032258  24.826923   \n",
       "13   air_0647f17b4dc041c8  37.064516  35.444444  39.225806  30.636364   \n",
       "14   air_064e203265ee5753  20.272727  24.809524  24.916667  19.937500   \n",
       "15   air_066f0221b8a4d533  13.482759  10.740741  18.392857  12.428571   \n",
       "16   air_06f95ac5c33aca10  17.617021  23.673469  26.672727  25.511111   \n",
       "17   air_0728814bd98f7367   8.941176   9.518519  11.200000   9.900000   \n",
       "18   air_0768ab3910f7967f  18.775000  25.027027  19.767442  25.897436   \n",
       "19   air_07b314d83059c4d2  39.733333  35.464286  43.354839  37.272727   \n",
       "20   air_07bb665f9cdfbdfb  25.454545  27.510204  34.660000  30.700000   \n",
       "21   air_082908692355165e  40.377358  42.075472  44.215686  47.897959   \n",
       "22   air_083ddc520ea47e1e   8.304348   8.294118  19.380952  12.625000   \n",
       "23   air_0845d8395f30c6bb  16.629630  22.407407  24.862069  22.954545   \n",
       "24   air_084d98859256acf0  16.083333  14.818182  15.615385  15.526316   \n",
       "25   air_0867f7bebad6a649  22.269231  18.964286  29.344828  21.681818   \n",
       "26   air_08ba8cd01b3ba010  10.413793  10.433962   9.426230  10.280000   \n",
       "27   air_08cb3c4ee6cd6a22  16.516129  14.142857  14.677419  12.842105   \n",
       "28   air_08ef81d5b7a0d13f  10.125000  13.625000  13.640000  12.315789   \n",
       "29   air_08f994758a1e76d4  28.357143  25.964286  27.733333  27.090909   \n",
       "..                    ...        ...        ...        ...        ...   \n",
       "799  air_f6b2489ccf873c3b  15.534483  15.767857  15.612903  16.423077   \n",
       "800  air_f6bfd27e2e174d16  16.560000  16.961538  15.962963  11.550000   \n",
       "801  air_f6cdaf7b7fdc6d78  14.071429  11.750000  11.137931   9.272727   \n",
       "802  air_f8233ad00755c35c  29.961538  36.680000  33.827586  30.333333   \n",
       "803  air_f85e21e543cf44f2   4.047619   4.523810   5.703704   5.411765   \n",
       "804  air_f88898cd09f40496  10.225806   8.785714   7.774194   7.950000   \n",
       "805  air_f911308e19d64236  33.860000  31.166667  38.129630  37.021277   \n",
       "806  air_f9168b23fdfc1e52   9.440000  11.960000  11.600000  17.181818   \n",
       "807  air_f927b2da69a82341  20.918919  19.804878  18.232558  15.967742   \n",
       "808  air_f957c6d6467d4d90   9.966667   8.000000  10.433333  10.181818   \n",
       "809  air_f96765e800907c77  48.086957  46.250000  49.230769  45.800000   \n",
       "810  air_fa12b40b02fecfd8  14.500000  14.535714  16.193548  16.090909   \n",
       "811  air_fa4ffc9057812fa2   6.933333   5.386364   7.145833   6.081633   \n",
       "812  air_fab092c35776a9b1  10.553571  12.500000  13.966667  11.568627   \n",
       "813  air_fb44f566d4f64a4e   0.000000   0.000000  21.333333  15.466667   \n",
       "814  air_fbadf737162a5ce3  16.938776  17.326531  17.490909  19.511111   \n",
       "815  air_fc477473134e9ae5  20.423077  17.500000  19.129032  14.363636   \n",
       "816  air_fcd4492c83f1c6b9  27.632653  26.962264  27.344828  25.955556   \n",
       "817  air_fcfbdcf7b1f82c6e  38.409091  31.037037  42.080000  36.368421   \n",
       "818  air_fd154088b1de6fa7   7.210526   5.176471   5.714286   6.705882   \n",
       "819  air_fd6aac1043520e83  31.586957  34.340426  33.377358  33.380952   \n",
       "820  air_fdc02ec4a3d21ea4  17.933333  15.074074  11.866667   7.909091   \n",
       "821  air_fdcfef8bd859f650   3.458333   3.730769   4.566667   3.454545   \n",
       "822  air_fe22ef5a9cbef123  25.660714  22.122807  32.919355  23.711538   \n",
       "823  air_fe58c074ec1445ea  26.857143  29.608696  28.166667  36.166667   \n",
       "824  air_fea5dc9594450608  13.807692  18.041667  15.866667  16.227273   \n",
       "825  air_fee8dcf4d619598e  22.633333  27.714286  24.903226  26.727273   \n",
       "826  air_fef9ccb3ba0da2f7   6.565217   6.041667   7.000000   9.421053   \n",
       "827  air_ffcc2d5087e1b476  22.913043  19.791667  20.857143  19.500000   \n",
       "828  air_fff68b929994bfbd   5.038462   4.821429   5.000000   4.636364   \n",
       "\n",
       "            m6         m7         m8         m9        m10        m11  \n",
       "0    26.080000  24.166667  22.833333  23.250000  22.625000  30.428571  \n",
       "1     0.000000   0.000000   0.000000  10.000000   8.260870  10.333333  \n",
       "2     8.178571  10.125000  10.954545   9.153846   9.600000  12.000000  \n",
       "3     8.000000   6.100000  10.500000  10.666667   3.888889  10.666667  \n",
       "4    13.777778  11.444444   9.333333   7.407407  12.272727   9.357143  \n",
       "5    29.483871  32.840000  24.733333  23.451613  21.266667  17.666667  \n",
       "6    22.857143  21.166667  20.241379  23.962963  27.880000  32.464286  \n",
       "7    37.038462  31.333333  34.884615  31.307692  31.370370  49.269231  \n",
       "8    38.806452  29.548387  35.400000  35.322581  34.200000  35.833333  \n",
       "9    11.346154  12.111111  12.000000   9.777778  10.107143  13.200000  \n",
       "10   16.129032  15.322581  16.172414  23.870968  26.233333  31.233333  \n",
       "11    7.000000   5.214286   4.250000   3.607143   3.814815   4.642857  \n",
       "12   21.870968  22.965517  24.233333  23.225806  22.633333  25.774194  \n",
       "13   36.857143  30.428571  32.166667  41.322581  40.714286  38.354839  \n",
       "14   19.291667  15.363636  16.708333  21.583333  21.227273  32.347826  \n",
       "15   13.903226  16.379310  15.785714  10.464286  15.357143  15.571429  \n",
       "16   22.888889  16.708333  16.346154  17.120000  22.038462  25.040000  \n",
       "17   12.548387   9.285714   8.137931   9.633333   8.760000   9.416667  \n",
       "18   21.761905  10.086957   7.958333  23.764706  20.411765  24.318182  \n",
       "19   26.387097  25.096774  22.600000  24.838710  31.933333  47.233333  \n",
       "20   35.846154  42.500000  26.958333  26.423077  25.304348  23.080000  \n",
       "21   39.392857  29.821429  37.821429  39.851852  38.428571  48.571429  \n",
       "22   12.291667  13.285714   8.954545   5.750000   4.941176   7.875000  \n",
       "23   22.733333  19.551724  23.034483  20.965517  19.433333  27.000000  \n",
       "24   15.560000  14.840000  12.541667  14.080000  12.434783  15.370370  \n",
       "25    0.000000   0.000000  25.840000  18.483871  19.433333  29.137931  \n",
       "26   11.483871   9.733333   9.300000  10.724138  10.357143  12.433333  \n",
       "27   15.300000  15.100000  15.466667  15.600000  13.100000  17.766667  \n",
       "28   14.071429  12.782609  16.909091  14.370370  12.695652  19.680000  \n",
       "29   23.225806  25.774194  22.931034  23.645161  29.241379  28.500000  \n",
       "..         ...        ...        ...        ...        ...        ...  \n",
       "799  16.129032  14.933333  16.300000  16.064516  15.733333  17.161290  \n",
       "800  15.708333  15.772727  12.760000  11.884615  17.333333  20.137931  \n",
       "801  10.481481  11.259259   8.185185  10.428571   8.866667   9.692308  \n",
       "802  37.961538  38.814815  35.392857  34.370370  34.222222  39.074074  \n",
       "803   5.600000   5.428571   4.173913   6.125000   5.434783   3.500000  \n",
       "804   8.642857   6.740741   7.933333   5.642857   6.961538   8.034483  \n",
       "805  35.750000  33.391304  34.538462  37.346154  37.384615  46.185185  \n",
       "806  12.285714  12.800000  12.740741  13.689655  11.384615  11.666667  \n",
       "807  11.238095  11.550000  10.400000  10.000000   9.631579  13.181818  \n",
       "808   9.935484   7.290323  11.666667  13.064516  10.900000  11.193548  \n",
       "809  37.038462  23.040000  23.846154  25.192308  38.000000  46.592593  \n",
       "810  19.666667  15.461538  15.384615  19.000000  12.960000  19.074074  \n",
       "811   7.259259   4.750000   7.739130   9.000000   5.590909   7.130435  \n",
       "812   7.258065   9.666667   9.928571  13.068966  11.000000  13.200000  \n",
       "813  25.161290  12.290323  13.655172  15.000000  12.000000   0.000000  \n",
       "814  24.538462  23.423077  23.076923  22.555556  18.720000  23.666667  \n",
       "815  19.709677  18.344828  16.068966  15.677419  16.392857  27.290323  \n",
       "816  29.172414  24.034483  28.000000  22.730769  24.428571  34.607143  \n",
       "817  33.366667  38.096774  38.551724  36.115385  28.423077  53.000000  \n",
       "818   6.111111   4.437500   5.761905   7.466667   5.230769   6.300000  \n",
       "819  34.153846  26.173913  33.956522  31.840000  31.166667  39.086957  \n",
       "820  13.321429   9.678571  10.964286  18.466667  18.766667  25.774194  \n",
       "821   2.117647   1.166667   1.333333   0.000000   3.210526   4.592593  \n",
       "822  21.580645  25.516129  26.900000  30.000000  26.400000  39.064516  \n",
       "823  30.772727  24.000000  25.909091  41.736842  26.500000  26.350000  \n",
       "824  13.586207  13.750000  13.423077  12.433333  11.333333  17.344828  \n",
       "825  29.193548  26.233333  27.666667  23.838710  22.633333  29.640000  \n",
       "826  13.296296  10.772727  12.384615  10.333333  11.120000   8.720000  \n",
       "827  20.884615  18.090909  19.200000  18.560000  21.440000  20.880000  \n",
       "828   5.076923   5.440000   4.857143   4.888889   5.827586   5.206897  \n",
       "\n",
       "[829 rows x 11 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
